﻿CREATE TABLE [dbo].[CiLog] (
    [Id]            INT            IDENTITY (1, 1) NOT NULL,
    [ProcessId]     NVARCHAR (100) NOT NULL,
    [ProcessName]   NVARCHAR (200) NULL,
    [MethodEngName] NVARCHAR (50)  NULL,
    [MethodName]    NVARCHAR (200) NOT NULL,
    [UserRealName]  NVARCHAR (50)  NULL,
    [Parameters]    NVARCHAR (200) NULL,
    [IPAddress]     NVARCHAR (50)  NULL,
    [WebUrl]        NVARCHAR (800) NULL,
    [Description]   NVARCHAR (800) NULL,
    [CreateOn]      DATETIME       DEFAULT (getdate()) NOT NULL,
    [CreateUserId]  NVARCHAR (50)  NULL,
    [CreateBy]      NVARCHAR (50)  NULL,
    CONSTRAINT [PK_CILOG] PRIMARY KEY NONCLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [index_CreateOn]
    ON [dbo].[CiLog]([CreateOn] ASC);

